How to: Display the current date in a worksheet.
Solution:
Use the TODAY() function.
1) Select the cell to display the current date.
2) Type an equal sign and the TODAY command:
=TODAY()
NOTE: The TODAY() function does not require arguments within the parentheses.
3) Press ENTER.
NOTE: This function returns the current date and updates the date automatically based on the computer's internal clock.
